Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	7322083
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	761.1 MiB
Average record size in memory	109.0 B

Variable types

Categorical	3
Numeric	8
Text	1
Boolean	9

Alerts

`Severity` is highly imbalanced (55.5%)	Imbalance
`Amenity` is highly imbalanced (90.3%)	Imbalance
`Give_Way` is highly imbalanced (95.7%)	Imbalance
`Junction` is highly imbalanced (62.0%)	Imbalance
`No_Exit` is highly imbalanced (97.4%)	Imbalance
`Railway` is highly imbalanced (92.8%)	Imbalance
`Stop` is highly imbalanced (81.7%)	Imbalance
`Traffic_Calming` is highly imbalanced (98.9%)	Imbalance
`Distance(mi)` is highly skewed (γ1 = 20.84234685)	Skewed
`Duration_Seconds` is highly skewed (γ1 = 57.733736)	Skewed
`Distance(mi)` has 3191789 (43.6%) zeros	Zeros
`Wind_Speed(mph)` has 925132 (12.6%) zeros	Zeros

Reproduction

Analysis started	2024-11-27 15:54:24.375971
Analysis finished	2024-11-27 15:58:26.792373
Duration	4 minutes and 2.42 seconds
Software version	ydata-profiling vv4.11.0
Download configuration	config.json

Severity
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.7 MiB

2	5823785
3	1254426
4	181455
1	62417

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	7322083
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	2
3rd row	2
4th row	3
5th row	2

Common Values

Value	Count	Frequency (%)
2	5823785	79.5%
3	1254426	17.1%
4	181455	2.5%
1	62417	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	5823785	79.5%
3	1254426	17.1%
4	181455	2.5%
1	62417	0.9%

Most occurring characters

Value	Count	Frequency (%)
2	5823785	79.5%
3	1254426	17.1%
4	181455	2.5%
1	62417	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7322083	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	5823785	79.5%
3	1254426	17.1%
4	181455	2.5%
1	62417	0.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	7322083	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	5823785	79.5%
3	1254426	17.1%
4	181455	2.5%
1	62417	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7322083	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	5823785	79.5%
3	1254426	17.1%
4	181455	2.5%
1	62417	0.9%

Distance(mi)
Real number (ℝ)

Skewed Zeros

Distinct	21923
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.55167825

Minimum	0
Maximum	441.75
Zeros	3191789
Zeros (%)	43.6%
Negative	0
Negative (%)	0.0%
Memory size	111.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.023
Q3	0.449
95-th percentile	2.625
Maximum	441.75
Range	441.75
Interquartile range (IQR)	0.449

Descriptive statistics

Standard deviation	1.7619337
Coefficient of variation (CV)	3.1937704
Kurtosis	1754.3228
Mean	0.55167825
Median Absolute Deviation (MAD)	0.023
Skewness	20.842347
Sum	4039434
Variance	3.1044103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3191789	43.6%
0.01	255269	3.5%
0.008	13387	0.2%
0.009999999776	13051	0.2%
0.009	12778	0.2%
0.007	11356	0.2%
0.011	10660	0.1%
0.03	10490	0.1%
0.024	10106	0.1%
0.028	10044	0.1%
Other values (21913)	3783153	51.7%

Value	Count	Frequency (%)
0	3191789	43.6%
0.001	4903	0.1%
0.002	2655	< 0.1%
0.003	3814	0.1%
0.004	5719	0.1%
0.005	7531	0.1%
0.006	9262	0.1%
0.007	11356	0.2%
0.008	13387	0.2%
0.009	12778	0.2%

Value	Count	Frequency (%)
441.75	1	< 0.1%
336.5700073	1	< 0.1%
333.6300049	1	< 0.1%
254.3999939	1	< 0.1%
251.2200012	1	< 0.1%
242.3399963	1	< 0.1%
227.2100067	1	< 0.1%
224.5899963	1	< 0.1%
210.0800018	1	< 0.1%
194.7299957	1	< 0.1%

Temperature(F)
Real number (ℝ)

Distinct	859
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.755685

Minimum	-89
Maximum	207
Zeros	2640
Zeros (%)	< 0.1%
Negative	18664
Negative (%)	0.3%
Memory size	111.7 MiB

Quantile statistics

Minimum	-89
5-th percentile	28
Q1	49.6
median	64
Q3	76
95-th percentile	89
Maximum	207
Range	296
Interquartile range (IQR)	26.4

Descriptive statistics

Standard deviation	18.952283
Coefficient of variation (CV)	0.30689132
Kurtosis	0.015305923
Mean	61.755685
Median Absolute Deviation (MAD)	13
Skewness	-0.51929113
Sum	4.5218025 × 10⁸
Variance	359.18904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
77	165390	2.3%
73	165121	2.3%
68	158546	2.2%
72	155309	2.1%
75	153105	2.1%
70	150241	2.1%
63	144607	2.0%
59	144125	2.0%
64	142995	2.0%
79	142524	1.9%
Other values (849)	5800120	79.2%

Value	Count	Frequency (%)
-89	10	< 0.1%
-58	1	< 0.1%
-50	1	< 0.1%
-45	1	< 0.1%
-44	1	< 0.1%
-40	1	< 0.1%
-38	3	< 0.1%
-37	5	< 0.1%
-36	2	< 0.1%
-35	100	< 0.1%

Value	Count	Frequency (%)
207	3	< 0.1%
196	5	< 0.1%
189	1	< 0.1%
174	2	< 0.1%
172	2	< 0.1%
170.6	1	< 0.1%
168.8	1	< 0.1%
167	1	< 0.1%
162	2	< 0.1%
161.6	1	< 0.1%

Humidity(%)
Real number (ℝ)

Distinct	101
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.847068

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	111.7 MiB

Quantile statistics

Minimum	1
5-th percentile	24
Q1	48
median	67
Q3	84
95-th percentile	97
Maximum	100
Range	99
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	22.743121
Coefficient of variation (CV)	0.35071934
Kurtosis	-0.71023811
Mean	64.847068
Median Absolute Deviation (MAD)	18
Skewness	-0.39646953
Sum	4.7481561 × 10⁸
Variance	517.24956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
93	279922	3.8%
100	275338	3.8%
87	164294	2.2%
90	161218	2.2%
89	134934	1.8%
96	130036	1.8%
84	122724	1.7%
81	122706	1.7%
82	119911	1.6%
86	116643	1.6%
Other values (91)	5694357	77.8%

Value	Count	Frequency (%)
1	45	< 0.1%
2	187	< 0.1%
3	642	< 0.1%
4	2074	< 0.1%
5	3959	0.1%
6	5771	0.1%
7	7674	0.1%
8	9163	0.1%
9	10643	0.1%
10	12933	0.2%

Value	Count	Frequency (%)
100	275338	3.8%
99	13650	0.2%
98	6643	0.1%
97	85306	1.2%
96	130036	1.8%
95	9191	0.1%
94	114635	1.6%
93	279922	3.8%
92	64024	0.9%
91	36215	0.5%

Pressure(in)
Real number (ℝ)

Distinct	1138
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.54687

Minimum	0
Maximum	58.63
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	111.7 MiB

Quantile statistics

Minimum	0
5-th percentile	28.13
Q1	29.38
median	29.86
Q3	30.03
95-th percentile	30.26
Maximum	58.63
Range	58.63
Interquartile range (IQR)	0.65

Descriptive statistics

Standard deviation	0.99363267
Coefficient of variation (CV)	0.033629034
Kurtosis	22.216221
Mean	29.54687
Median Absolute Deviation (MAD)	0.24
Skewness	-3.677962
Sum	2.1634463 × 10⁸
Variance	0.98730589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29.96	119591	1.6%
29.99	118259	1.6%
30.01	116322	1.6%
29.94	115570	1.6%
30.04	110820	1.5%
29.97	108933	1.5%
30.03	107648	1.5%
29.91	107376	1.5%
30	106671	1.5%
29.95	106476	1.5%
Other values (1128)	6204417	84.7%

Value	Count	Frequency (%)
0	2	< 0.1%
0.02	1	< 0.1%
0.12	1	< 0.1%
0.29	2	< 0.1%
0.3	6	< 0.1%
0.39	1	< 0.1%
2.98	1	< 0.1%
2.99	9	< 0.1%
3	2	< 0.1%
3.01	2	< 0.1%

Value	Count	Frequency (%)
58.63	7	< 0.1%
58.39	2	< 0.1%
58.32	1	< 0.1%
58.13	1	< 0.1%
58.1	4	< 0.1%
58.04	3	< 0.1%
58.03	1	< 0.1%
57.74	1	< 0.1%
57.54	2	< 0.1%
56.54	1	< 0.1%

Visibility(mi)
Real number (ℝ)

Distinct	92
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.0920209

Minimum	0
Maximum	140
Zeros	7244
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	111.7 MiB

Quantile statistics

Minimum	0
5-th percentile	2.5
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	140
Range	140
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.6866835
Coefficient of variation (CV)	0.29549904
Kurtosis	82.278606
Mean	9.0920209
Median Absolute Deviation (MAD)	0
Skewness	2.356617
Sum	66572532
Variance	7.2182681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	5870512	80.2%
7	209935	2.9%
9	182476	2.5%
8	145473	2.0%
5	139633	1.9%
6	122639	1.7%
2	117446	1.6%
4	116104	1.6%
3	113982	1.6%
1	98467	1.3%
Other values (82)	205416	2.8%

Value	Count	Frequency (%)
0	7244	0.1%
0.06	318	< 0.1%
0.1	1273	< 0.1%
0.12	1716	< 0.1%
0.19	40	< 0.1%
0.2	11891	0.2%
0.25	25975	0.4%
0.31	4	< 0.1%
0.38	322	< 0.1%
0.4	94	< 0.1%

Value	Count	Frequency (%)
140	3	< 0.1%
130	1	< 0.1%
120	4	< 0.1%
111	3	< 0.1%
110	1	< 0.1%
105	1	< 0.1%
101	1	< 0.1%
100	46	< 0.1%
98	1	< 0.1%
90	12	< 0.1%

Wind_Direction
Categorical

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.7 MiB

CALM	1287985
S	581407
W	533137
N	433556
SSW	374180
Other values (13)	4111818

Length

Max length	4
Median length	3
Mean length	2.4807469
Min length	1

Characters and Unicode

Total characters	18164235
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CALM
2nd row	CALM
3rd row	SW
4th row	SW
5th row	SW

Common Values

Value	Count	Frequency (%)
CALM	1287985	17.6%
S	581407	7.9%
W	533137	7.3%
N	433556	5.9%
SSW	374180	5.1%
E	371643	5.1%
WNW	367128	5.0%
NW	357974	4.9%
VAR	355283	4.9%
SW	354509	4.8%
Other values (8)	2305281	31.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
calm	1287985	17.6%
s	581407	7.9%
w	533137	7.3%
n	433556	5.9%
ssw	374180	5.1%
e	371643	5.1%
wnw	367128	5.0%
nw	357974	4.9%
var	355283	4.9%
sw	354509	4.8%
Other values (8)	2305281	31.5%

Most occurring characters

Value	Count	Frequency (%)
W	3365907	18.5%
S	3256030	17.9%
N	2802684	15.4%
E	2521825	13.9%
A	1643268	9.0%
C	1287985	7.1%
L	1287985	7.1%
M	1287985	7.1%
V	355283	2.0%
R	355283	2.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18164235	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	3365907	18.5%
S	3256030	17.9%
N	2802684	15.4%
E	2521825	13.9%
A	1643268	9.0%
C	1287985	7.1%
L	1287985	7.1%
M	1287985	7.1%
V	355283	2.0%
R	355283	2.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18164235	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	3365907	18.5%
S	3256030	17.9%
N	2802684	15.4%
E	2521825	13.9%
A	1643268	9.0%
C	1287985	7.1%
L	1287985	7.1%
M	1287985	7.1%
V	355283	2.0%
R	355283	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18164235	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	3365907	18.5%
S	3256030	17.9%
N	2802684	15.4%
E	2521825	13.9%
A	1643268	9.0%
C	1287985	7.1%
L	1287985	7.1%
M	1287985	7.1%
V	355283	2.0%
R	355283	2.0%

Wind_Speed(mph)
Real number (ℝ)

Zeros

Distinct	185
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6932572

Minimum	0
Maximum	1087
Zeros	925132
Zeros (%)	12.6%
Negative	0
Negative (%)	0.0%
Memory size	111.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4.6
median	7
Q3	10
95-th percentile	17
Maximum	1087
Range	1087
Interquartile range (IQR)	5.4

Descriptive statistics

Standard deviation	5.2778851
Coefficient of variation (CV)	0.68604038
Kurtosis	1184.1536
Mean	7.6932572
Median Absolute Deviation (MAD)	3
Skewness	8.5032673
Sum	56330667
Variance	27.856071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	925132	12.6%
5	516084	7.0%
6	499677	6.8%
3	496232	6.8%
7	464835	6.3%
8	418199	5.7%
9	376416	5.1%
7.685489596	376185	5.1%
10	313672	4.3%
12	271322	3.7%
Other values (175)	2664329	36.4%

Value	Count	Frequency (%)
0	925132	12.6%
1	186	< 0.1%
1.2	440	< 0.1%
2	433	< 0.1%
2.3	884	< 0.1%
3	496232	6.8%
3.5	200774	2.7%
4.6	214579	2.9%
5	516084	7.0%
5.8	213018	2.9%

Value	Count	Frequency (%)
1087	1	< 0.1%
984	1	< 0.1%
822.8	7	< 0.1%
812	1	< 0.1%
703.1	2	< 0.1%
580	2	< 0.1%
518	2	< 0.1%
471.8	1	< 0.1%
328	1	< 0.1%
255	1	< 0.1%

Weather_Condition
Text

Distinct	143
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.7 MiB

Length

Max length	35
Median length	30
Mean length	7.6935312
Min length	3

Characters and Unicode

Total characters	56332674
Distinct characters	46
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	Light Rain
2nd row	Light Rain
3rd row	Overcast
4th row	Mostly Cloudy
5th row	Mostly Cloudy

Value	Count	Frequency (%)
cloudy	2495851	24.6%
fair	2489918	24.5%
mostly	1005835	9.9%
clear	800266	7.9%
partly	690653	6.8%
light	527963	5.2%
rain	494589	4.9%
overcast	379113	3.7%
scattered	202817	2.0%
clouds	202817	2.0%
Other values (50)	856631	8.4%

Most occurring characters

Value	Count	Frequency (%)
l	5234866	9.3%
a	5206145	9.2%
r	4714723	8.4%
y	4377429	7.8%
o	4031190	7.2%
i	3775869	6.7%
C	3498956	6.2%
t	3128158	5.6%
d	3074729	5.5%
	2824370	5.0%
Other values (36)	16466239	29.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	43366223	77.0%
Uppercase Letter	10008381	17.8%
Space Separator	2824370	5.0%
Other Punctuation	106270	0.2%
Dash Punctuation	27430	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	5234866	12.1%
a	5206145	12.0%
r	4714723	10.9%
y	4377429	10.1%
o	4031190	9.3%
i	3775869	8.7%
t	3128158	7.2%
d	3074729	7.1%
u	2758249	6.4%
e	1855563	4.3%
Other values (15)	5209302	12.0%

Uppercase Letter

Value	Count	Frequency (%)
C	3498956	35.0%
F	2600430	26.0%
M	1020825	10.2%
P	698058	7.0%
L	527968	5.3%
R	494589	4.9%
S	403152	4.0%
O	379113	3.8%
H	127546	1.3%
W	115023	1.1%
Other values (8)	142721	1.4%

Space Separator

Value	Count	Frequency (%)
	2824370	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	106270	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	27430	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	53374604	94.7%
Common	2958070	5.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	5234866	9.8%
a	5206145	9.8%
r	4714723	8.8%
y	4377429	8.2%
o	4031190	7.6%
i	3775869	7.1%
C	3498956	6.6%
t	3128158	5.9%
d	3074729	5.8%
u	2758249	5.2%
Other values (33)	13574290	25.4%

Common

Value	Count	Frequency (%)
	2824370	95.5%
/	106270	3.6%
-	27430	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56332674	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	5234866	9.3%
a	5206145	9.2%
r	4714723	8.4%
y	4377429	7.8%
o	4031190	7.2%
i	3775869	6.7%
C	3498956	6.2%
t	3128158	5.6%
d	3074729	5.5%
	2824370	5.0%
Other values (36)	16466239	29.2%

Amenity
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	7230591
True	91492

Value	Count	Frequency (%)
False	7230591	98.8%
True	91492	1.2%

Crossing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	6484389
True	837694

Value	Count	Frequency (%)
False	6484389	88.6%
True	837694	11.4%

Give_Way
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	7287753
True	34330

Value	Count	Frequency (%)
False	7287753	99.5%
True	34330	0.5%

Junction
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	6781931
True	540152

Value	Count	Frequency (%)
False	6781931	92.6%
True	540152	7.4%

No_Exit
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	7303340
True	18743

Value	Count	Frequency (%)
False	7303340	99.7%
True	18743	0.3%

Railway
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	7258927
True	63156

Value	Count	Frequency (%)
False	7258927	99.1%
True	63156	0.9%

Stop
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	7118666
True	203417

Value	Count	Frequency (%)
False	7118666	97.2%
True	203417	2.8%

Traffic_Calming
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	7314845
True	7238

Value	Count	Frequency (%)
False	7314845	99.9%
True	7238	0.1%

Traffic_Signal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.8 MiB

False	6229219
True	1092864

Value	Count	Frequency (%)
False	6229219	85.1%
True	1092864	14.9%

Civil_Twilight
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.7 MiB

Day	5443919
Night	1878164

Length

Max length	5
Median length	3
Mean length	3.5130136
Min length	3

Characters and Unicode

Total characters	25722577
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Night
3rd row	Night
4th row	Day
5th row	Day

Common Values

Value	Count	Frequency (%)
Day	5443919	74.3%
Night	1878164	25.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
day	5443919	74.3%
night	1878164	25.7%

Most occurring characters

Value	Count	Frequency (%)
D	5443919	21.2%
a	5443919	21.2%
y	5443919	21.2%
N	1878164	7.3%
i	1878164	7.3%
g	1878164	7.3%
h	1878164	7.3%
t	1878164	7.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18400494	71.5%
Uppercase Letter	7322083	28.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	5443919	29.6%
y	5443919	29.6%
i	1878164	10.2%
g	1878164	10.2%
h	1878164	10.2%
t	1878164	10.2%

Uppercase Letter

Value	Count	Frequency (%)
D	5443919	74.3%
N	1878164	25.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25722577	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	5443919	21.2%
a	5443919	21.2%
y	5443919	21.2%
N	1878164	7.3%
i	1878164	7.3%
g	1878164	7.3%
h	1878164	7.3%
t	1878164	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25722577	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	5443919	21.2%
a	5443919	21.2%
y	5443919	21.2%
N	1878164	7.3%
i	1878164	7.3%
g	1878164	7.3%
h	1878164	7.3%
t	1878164	7.3%

Duration_Seconds
Real number (ℝ)

Skewed

Distinct	73293
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23014.308

Minimum	73
Maximum	1.6877634 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	111.7 MiB

Quantile statistics

Minimum	73
5-th percentile	1724
Q1	1832
median	4460
Q3	7454
95-th percentile	21600
Maximum	1.6877634 × 10⁸
Range	1.6877627 × 10⁸
Interquartile range (IQR)	5622

Descriptive statistics

Standard deviation	739408.6
Coefficient of variation (CV)	32.128213
Kurtosis	4889.1976
Mean	23014.308
Median Absolute Deviation (MAD)	2670
Skewness	57.733736
Sum	1.6851267 × 10¹¹
Variance	5.4672508 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21600	346938	4.7%
1800	106517	1.5%
2700	64891	0.9%
4500	57288	0.8%
3600	55095	0.8%
14400	54876	0.7%
1785	54678	0.7%
1786	54523	0.7%
1787	53640	0.7%
1784	52896	0.7%
Other values (73283)	6420741	87.7%

Value	Count	Frequency (%)
73	1	< 0.1%
115	1	< 0.1%
120	2	< 0.1%
150	3	< 0.1%
152	1	< 0.1%
180	16	< 0.1%
210	6	< 0.1%
221	1	< 0.1%
229	1	< 0.1%
240	12	< 0.1%

Value	Count	Frequency (%)
168776340	2	< 0.1%
134184345	1	< 0.1%
134181332	3	< 0.1%
134179838	3	< 0.1%
134176830	2	< 0.1%
106135755	1	< 0.1%
100954757	1	< 0.1%
94755540	1	< 0.1%
94697995	1	< 0.1%
94697990	1	< 0.1%

cluster
Real number (ℝ)

Distinct	9976
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3663.3041

Minimum	0
Maximum	9999
Zeros	289
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	83.8 MiB

Quantile statistics

Minimum	0
5-th percentile	133
Q1	1046
median	2981
Q3	5988
95-th percentile	9062
Maximum	9999
Range	9999
Interquartile range (IQR)	4942

Descriptive statistics

Standard deviation	2927.3721
Coefficient of variation (CV)	0.79910705
Kurtosis	-0.96902016
Mean	3663.3041
Median Absolute Deviation (MAD)	2263
Skewness	0.52475693
Sum	2.6823016 × 10¹⁰
Variance	8569507.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	28971	0.4%
124	27113	0.4%
285	24498	0.3%
253	23196	0.3%
493	20698	0.3%
175	19772	0.3%
297	18484	0.3%
877	17216	0.2%
414	16039	0.2%
229	15513	0.2%
Other values (9966)	7110583	97.1%

Value	Count	Frequency (%)
0	289	< 0.1%
1	1640	< 0.1%
2	2581	< 0.1%
3	618	< 0.1%
4	3780	0.1%
5	2059	< 0.1%
6	2500	< 0.1%
7	299	< 0.1%
8	5488	0.1%
9	267	< 0.1%

Value	Count	Frequency (%)
9999	222	< 0.1%
9998	563	< 0.1%
9997	169	< 0.1%
9996	122	< 0.1%
9995	451	< 0.1%
9994	250	< 0.1%
9993	273	< 0.1%
9992	180	< 0.1%
9991	448	< 0.1%
9990	696	< 0.1%

Interactions

Correlations

	Amenity	Civil_Twilight	Crossing	Distance(mi)	Duration_Seconds	Give_Way	Humidity(%)	Junction	No_Exit	Pressure(in)	Railway	Severity	Stop	Temperature(F)	Traffic_Calming	Traffic_Signal	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	cluster
Amenity	1.000	0.006	0.149	0.000	0.001	0.006	0.014	0.026	0.014	0.022	0.050	0.040	0.034	0.010	0.023	0.106	0.002	0.020	0.000	0.022
Civil_Twilight	0.006	1.000	0.039	0.003	0.007	0.005	0.239	0.015	0.004	0.028	0.000	0.054	0.001	0.261	0.000	0.044	0.016	0.171	0.001	0.018
Crossing	0.149	0.039	1.000	0.004	0.007	0.059	0.034	0.088	0.062	0.034	0.179	0.123	0.118	0.050	0.038	0.476	0.007	0.044	0.001	0.021
Distance(mi)	0.000	0.003	0.004	1.000	0.401	0.000	-0.022	0.001	0.000	-0.122	0.000	0.006	0.001	-0.054	0.001	0.004	-0.007	0.001	-0.004	-0.005
Duration_Seconds	0.001	0.007	0.007	0.401	1.000	0.001	-0.024	0.008	0.000	-0.135	0.001	0.009	0.003	-0.022	0.000	0.008	0.011	0.004	-0.038	-0.029
Give_Way	0.006	0.005	0.059	0.000	0.001	1.000	0.005	0.009	0.007	0.008	0.003	0.009	0.030	0.005	0.003	0.073	0.007	0.006	0.000	0.011
Humidity(%)	0.014	0.239	0.034	-0.022	-0.024	0.005	1.000	0.010	0.009	0.057	0.006	0.027	0.026	-0.330	0.005	0.018	-0.463	0.086	-0.189	0.017
Junction	0.026	0.015	0.088	0.001	0.008	0.009	0.010	1.000	0.004	0.027	0.009	0.055	0.037	0.021	0.005	0.105	0.004	0.020	0.000	0.016
No_Exit	0.014	0.004	0.062	0.000	0.000	0.007	0.009	0.004	1.000	0.007	0.004	0.012	0.026	0.006	0.013	0.030	0.007	0.006	0.000	0.008
Pressure(in)	0.022	0.028	0.034	-0.122	-0.135	0.008	0.057	0.027	0.007	1.000	0.016	0.046	0.002	-0.008	0.004	0.035	0.066	0.027	0.006	-0.031
Railway	0.050	0.000	0.179	0.000	0.001	0.003	0.006	0.009	0.004	0.016	1.000	0.014	0.007	0.009	0.005	0.059	0.003	0.005	0.000	0.018
Severity	0.040	0.054	0.123	0.006	0.009	0.009	0.027	0.055	0.012	0.046	0.014	1.000	0.061	0.035	0.006	0.123	0.012	0.018	0.001	0.038
Stop	0.034	0.001	0.118	0.001	0.003	0.030	0.026	0.037	0.026	0.002	0.007	0.061	1.000	0.015	0.027	0.049	0.001	0.008	0.000	0.007
Temperature(F)	0.010	0.261	0.050	-0.054	-0.022	0.005	-0.330	0.021	0.006	-0.008	0.009	0.035	0.015	1.000	0.005	0.043	0.224	0.076	0.083	-0.046
Traffic_Calming	0.023	0.000	0.038	0.001	0.000	0.003	0.005	0.005	0.013	0.004	0.005	0.006	0.027	0.005	1.000	0.012	0.001	0.006	0.000	0.007
Traffic_Signal	0.106	0.044	0.476	0.004	0.008	0.073	0.018	0.105	0.030	0.035	0.059	0.123	0.049	0.043	0.012	1.000	0.003	0.035	0.001	0.033
Visibility(mi)	0.002	0.016	0.007	-0.007	0.011	0.007	-0.463	0.004	0.007	0.066	0.003	0.012	0.001	0.224	0.001	0.003	1.000	0.006	0.052	-0.012
Wind_Direction	0.020	0.171	0.044	0.001	0.004	0.006	0.086	0.020	0.006	0.027	0.005	0.018	0.008	0.076	0.006	0.035	0.006	1.000	0.002	0.015
Wind_Speed(mph)	0.000	0.001	0.001	-0.004	-0.038	0.000	-0.189	0.000	0.000	0.006	0.000	0.001	0.000	0.083	0.000	0.001	0.052	0.002	1.000	0.022
cluster	0.022	0.018	0.021	-0.005	-0.029	0.011	0.017	0.016	0.008	-0.031	0.018	0.038	0.007	-0.046	0.007	0.033	-0.012	0.015	0.022	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Severity	Distance(mi)	Temperature(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Weather_Condition	Amenity	Crossing	Give_Way	Junction	No_Exit	Railway	Stop	Traffic_Calming	Traffic_Signal	Civil_Twilight	Duration_Seconds	cluster
0	3	0.01	36.9	91.0	29.68	10.0	CALM	7.68549	Light Rain	False	False	False	False	False	False	False	False	False	Night	18840.0	2662
1	2	0.01	37.9	100.0	29.65	10.0	CALM	7.68549	Light Rain	False	False	False	False	False	False	False	False	False	Night	1800.0	6646
2	2	0.01	36.0	100.0	29.67	10.0	SW	3.50000	Overcast	False	False	False	False	False	False	False	False	True	Night	1800.0	2110
3	3	0.01	35.1	96.0	29.64	9.0	SW	4.60000	Mostly Cloudy	False	False	False	False	False	False	False	False	False	Day	1800.0	2132
4	2	0.01	36.0	89.0	29.65	6.0	SW	3.50000	Mostly Cloudy	False	False	False	False	False	False	False	False	True	Day	1800.0	7667
5	3	0.01	37.9	97.0	29.63	7.0	SSW	3.50000	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0	8714
6	2	0.00	34.0	100.0	29.66	7.0	WSW	3.50000	Overcast	False	False	False	False	False	False	False	False	False	Day	1800.0	7309
7	3	0.01	34.0	100.0	29.66	7.0	WSW	3.50000	Overcast	False	False	False	False	False	False	False	False	False	Day	1800.0	120
8	2	0.00	33.3	99.0	29.67	5.0	SW	1.20000	Mostly Cloudy	False	False	False	False	False	False	False	False	False	Day	1800.0	3024
9	3	0.01	37.4	100.0	29.62	3.0	SSW	4.60000	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0	8714

	Severity	Distance(mi)	Temperature(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Weather_Condition	Amenity	Crossing	Give_Way	Junction	No_Exit	Railway	Stop	Traffic_Calming	Traffic_Signal	Civil_Twilight	Duration_Seconds	cluster
7728384	2	0.390	78.0	52.0	29.69	10.0	VAR	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1723.0	1260
7728385	2	0.000	88.0	32.0	28.20	10.0	WNW	10.0	Fair	False	False	False	False	False	False	False	False	False	Day	1703.0	9070
7728386	2	0.189	73.0	68.0	29.76	10.0	W	9.0	Fair	False	False	False	True	False	False	False	False	False	Day	1703.0	457
7728387	2	0.443	75.0	60.0	29.74	10.0	SSW	9.0	Fair	False	False	False	False	False	False	False	False	False	Day	1711.0	143
7728388	2	0.000	81.0	48.0	28.78	10.0	ESE	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1711.0	1313
7728389	2	0.543	86.0	40.0	28.92	10.0	W	13.0	Fair	False	False	False	False	False	False	False	False	False	Day	1716.0	1237
7728390	2	0.338	70.0	73.0	29.39	10.0	SW	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1613.0	1679
7728391	2	0.561	73.0	64.0	29.74	10.0	SSW	10.0	Partly Cloudy	False	False	False	True	False	False	False	False	False	Day	1708.0	5
7728392	2	0.772	71.0	81.0	29.62	10.0	SW	8.0	Fair	False	False	False	False	False	False	False	False	False	Day	1761.0	641
7728393	2	0.537	79.0	47.0	28.63	7.0	SW	7.0	Fair	False	False	False	False	False	False	False	False	False	Day	1765.0	9070

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample